|
|
| Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Lost Hamster
Serenity and Hungarian Operational Team
   |
Posted - 2009.02.02 10:58:00 -
[1]
Nice application! :)
I have a question: I have my old transaction data in csv format, what you can download from the character sheet. Any idea how to import the to the database?
|
Lost Hamster
Serenity and Hungarian Operational Team
|
Posted - 2009.02.04 14:25:00 -
[2]
 Originally by: Hel O'Ween
I haven't used that data myself so far, so I first need to have a look. This might take a few days, as I've got a flu atm. 
First I wish you: get well!
Here is an example for one line of this csv format:
date,transID,quantity,type,price,clientName,stationName,transactionType,transactionFor
2009-02-01 16:22:00,868854448,3,150mm Railgun II,556899.98,Sell it,Jita IV - Moon 4 - Caldari Navy Assembly Plant,Buy,Personal
Unfortunately I don't know what format you get from the API. Does that contains station, region ID's? - what I saw in the database. Or you re-process the incoming data, and replace the stationName to this values? |
Lost Hamster
Serenity and Hungarian Operational Team
|
Posted - 2009.02.06 23:42:00 -
[3]
Edited by: Lost Hamster on 06/02/2009 23:42:23
Originally by: Hel O'Ween
The format is XML. See Extras -> Cached XML files. These are the files "as is" as provided by the API. And yes, the stationID is in there. From that I add the solarSystemID, regionID to the table while retrieving/storing the record in order to be able to do the breakdowns. I'm sorry, but I see no easy way (=not without programming) to import those files.
I don't know how familiar you're with Access. It can be done, but needs a couple of interim steps.
Actually I made it - just 5 hour work... The hardest part was the 0.0 station names to match to a stationID. Had to fill out all the details what you put to the transaction table. Had to re-import the data a couple times, until it was perfect. And I had to replace all the clientID, clientName to 100 , unknown. I tried to leave it empty, but the software didn't liked it.
So now I have my full transaction data back to 2007 jun. It was about 10k transactions. 
What I missed in the program is:
Balance sheet / And have a checkbox, to see personal or/and corporate transactions.
That's all for now. 
Have a nice weekend! |
Lost Hamster
Serenity and Hungarian Operational Team
|
Posted - 2009.02.07 13:36:00 -
[4]
Originally by: Hel O'Ween
Quote:
The hardest part was the 0.0 station names to match to a stationID. Had to fill out all the details what you put to the transaction table.
See http://wiki.eve-id.net/APIv2_Eve_ConquerableStationList_XML and http://api.eve-online.com/eve/ConquerableStationList.xml.aspx
The problem was that in the CSV, I had only the station names, and I had data which where 1.5 year old. And in 1.5 year many of the station names have changed. So I had to trace back the old name to a system name, Then check out the system, and see what is the new station name, and then get the ID of the station.
Quote:
Arent' clientID and clientName provided with the CSV? I thought so, at least. Otherwise, -1 is a good default choice.
Only the client name is there. Sadly there is no ID.
Quote:
As for personal or corporate transactions. Not sure what you mean here. In Extras -> Options -> Register "Wallet" you can define which data to import, personal only, corporate only, both. This is meant for transactions your char does for the corp.
I imported both data(corp/personal). But in the balance sheet, I want to see only the personal entries. I would like to filter out the entries what I made for my corp.
Quote:
Besides that, each window you open - journals, transactions, statistics, etc. - inherits its state from the character selection screen. If the option there is set to "Personal data", each window opened now refers to your personal wallet and won't change that state until it is closed.
It was always on Personal Data. I didn't even imported the corp data yet.
|
Lost Hamster
Serenity and Hungarian Operational Team
|
Posted - 2009.02.11 13:38:00 -
[5]
Originally by: Dame Thalia
I also tried on my alt but it gives me the same error. However other applications such as EVEMon work well with EVE API for both my accounts.
Maybe a local firewall issue, where the firewall is not allowing the connection to the eve website for the program?
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.04.03 12:41:00 -
[6]
Originally by: Hel O'Ween
I've released a new update to EWA, which fixes some small bugs.
For details, see http://eve.basicaware.de/evewalletaware/version.html
Cool, thanks!
I hope I can run it under Windows 7...
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.04.04 20:04:00 -
[7]
Yes it's working. But it was not enough to copy the old installation. I had to install it. I guess it's installing some component in the system32 folder. Otherwise it's failing to start.
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.04.11 18:24:00 -
[8]
Originally by: Hel O'Ween
Yes, you need to do an install. EWA uses an OCX, which needs to be registered (and hence needs admin privileges for installation), that's what the install does. But it keeps everything within the program folder. (I hate polluting the SYSTEM32 folder)
I managed to use it without to install it.
My problem was that in the c:\ProgramData\EVEWalletAware\EVEWalletAware.ini had a wrong path for the db location. :)
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2009.09.04 19:13:00 -
[9]
Hi,
Look's like I missed some of the updates...
I'm currently at 1.1.0.12, and the update to the latest version is not really working well.
Is there a way to get some intermediate version to be able to update correctly?
Like: 1.2 -> 1.2.5 -> 1.3 ?
Thanks in advance.
|
Lost Hamster
Hamster Holding Corp
|
Posted - 2010.01.10 02:33:00 -
[10]
Edited by: Lost Hamster on 10/01/2010 02:33:43
Originally by: Thynar
Same problem as Millimage above only that EWA was working till 24 hours ago. Tried upgrading to 1.3.7 with no success.
It's the same problem what we have with EMMA, the refID value is to big for int32.
Maybe there is a workaround here:
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1248114
|
|
|
|
|
| |
|